select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')
Yellow and Pink Quinceanera Dress Sweetheart Beading Ruffles
Multi-color Leopard Quinceanera Dress Sweetheart Beading Ruffles
Orange Strapless Printed Quinceanera Pick-ups Hand Made Flowers
2014 Fuchsia Quinceanera Dress Sweetheart Beading Full Skirt
Sweetheart Ball Gown Quinceanera Dress Light Blue Appliques
Beaded and Ruffled Dress for a Quinceanera in Orange and Rose Pink
Blue and White Strapless Sweet Sixteen Dresses with Beading Flowers
Beaded White and Blue Taffeta Sweet Sixteen Dresses with Pick ups
Appliques and Pick ups Accent Sweet 15 Dresses in Blue and Green
Beaded Blue Sweet 15 Dresses with Olive Green Sash and Pick ups
Blue Organza Quinceanera Gown Dresses with Appliques Pick ups
Appliques and Pick ups Accent Quinceanera Gowns of Lavender Organza
Beaded Fuchsia and Silver Ruffled Layers Quinceanera Gown Dress
Appliques Accent Strapless Floor Length Dress of 15 in Orange
Appliqued Strapless Quinceanera Dresses Gowns in Black and Purple
Black and Green Strapless Appliqued Quinceanera Dresses Gowns
White Organza Strapless Dress for Quinceanera with Red Flowers
Beading and Pick ups Accent White Organza Dress for Quinceanera
Beaded and Ruffled Dresses for A Quince in Gold and Black 2013
2013 New Colorful Appliqued Dresses for A Quince with Ruffles
Popular Colorful Dresses for A Quince with Beading and Ruffles
Greta Garbo Fuchsia and Black Dresses for A Quinceanera with Ruffles Beading
Beading and Pick ups Accent Blue Taffeta Dress for a Quinceanera
Hot Pink and Black Sweet 16 Dresses with Flowers and Ruffled Layers
2014 Colorful Tulle Sweet Sixteen Dresses with Beading Decorate
Beaded Sweetheart Organza Lace-up Sweet 15 Dresses in Baby Blue
White Taffeta Strapless Sweet 15 Dresses with Beaded Red Belt
Apple Green Strapless Long Quinceanera Dress with Appliques 2013
Beaded Corset Pick ups Taffeta Quinceanera Dress in Royal Blue
Olive Green Taffeta Quinceanera Gown with Appliques and Pick ups